Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# MAXBYTES

The MAXBYTES function counts the number of bytes in the longest line of a multiline text expression. The result returned by MAXBYTES has the same dimensions as the specified expression.

Return Value

INTEGER

Syntax

MAXBYTES(text-expression)

Arguments

text-expression

  The `TEXT` expression whose bytes for each line are to be counted.

Examples

Example 17-1 Finding the Length of the Longest Line Using Bytes

You would like to know the length of the longest line in a text variable called `mytext`. The following example shows the value of the variable and the result returned by MAXBYTES.

The statement

    SHOW mytext

produces the following output.

    This is a multiline text variable.
    The longest line is this one in the middle.
    The third line is short.

The statement

    SHOW MAXBYTES(mytext)

produces the following output.

    43